package com.quanyan.travel.mapper;

import com.quanyan.travel.entity.vo.DestinationVo;
import com.quanyan.travel.entity.vo.Master;
import com.quanyan.travel.entity.vo.ProductDetail;
import com.quanyan.travel.entity.vo.SeasonActivityVo;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

public interface VTravelUserDefinedMapper {

    List<ProductDetail> queryProductDetail(List<Integer> ids);

    int updateTravelStorage(@Param("productId")Integer productId,
                            @Param("num") Integer num);

    int recoveryTravelStorage(@Param("productId")Integer productId,
                            @Param("num") Integer num);

    List<Master> queryOutdoorMaster(List<Integer> ids);

    List<Integer> getActivityIds(@Param("cityId") Integer cityId);

    List<DestinationVo> queryDestination(Integer activityId);

    List<SeasonActivityVo> querySeasonActivityList(List<Integer> productids);

    List<Integer> selectExpireActivity();

    List<Integer> getIndexNotShwoActivity();

    List<ProductDetail> searchUsableProductDetail(@Param("key") String key,
                                                  @Param("begin") Integer begin,
                                                  @Param("pageSize") Integer pageSize);

    int updateExpireThemeActivity();

    int updateExpireTheme();

    int updatePriceThemeActivity(@Param("activityId") Integer activityId);

    int updatePriceActivity(@Param("activityId") Integer activityId);

    int updateStartTimeActivity(@Param("activityId") Integer activityId);

    int updateThemeMinTime(@Param("activityId") Integer activityId);

    Integer getActivityIdByActivityId(@Param("activityId") Integer activityId);

    String getDestinationName(@Param("activityId") Integer activityId);

    BigDecimal lowThemePrice(@Param("activityId") Integer activityId);



}
